﻿DROP TABLE IF EXISTS `open_group_promotion_goods`;
CREATE TABLE `open_group_promotion_goods` (
  `promotion_goods_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `group_promotion_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_type_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `goods_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `admin_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`promotion_goods_id`),
  KEY `group_promotion_id` (`group_promotion_id`),
  KEY `goods_type_id` (`goods_type_id`),
  KEY `goods_id` (`goods_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;